UBB.Developers Forums Community Development Programming MySQL and Server Configuration SQL command query

Hi,

I have just moved the location of my forums - and have noticed that under U_Picture I have several 'old' urls for avatars.

The actual avatars have all been copied over - but I need to change say http://forums.nonleague.com/uploads/4245.jpg to http://www.fansfocus.com/forum/uploads/4245.jpg

Of course the actual link varies in virtually every user.

How can I change a couple of thousand users, but keep part of the link?

I have been fiddling with commands, but none of them do the job.

Thanks.

Ian

UPDATE w3t_Users SET `U_Picture` = REPLACE(`U_Picture`, 'http://forums.nonleague.com/uploads','http://www.fansfocus.com/forum/uploads');

[:"red"]disclaimer.. BACK UP YOUR DATABASE FIRST!!!!! [/]

Thanks - I was very close, but not close enough

What do you mean about back up? We British never back up - always going forward

I thought the Brist were the original inventors of the BackDoor?